Agile ADO.Net Persistence Layer (AAPL)

aapl.zip (1,4 MB)
I've been impressed by the coding efficiencies that can be gained from ORMs like EF or Hibernate. Those tools allow you to embrace change and work in a much more agile way. This is my attempt to produce similar results using good old ADO.Net (which is still my favorite).

ActiveRecord in C# by Abel Perez

This ActiveRecord Framework was kicked off before the launch of C# 3.0 and LINQ and might be a little outdated relative to some of the things you can do now a days right out the box.

AffinityORM .NET O/R Mapper Simple is better

No designers No massive unreadable code files Having been frustrated with clunky designers and unmanageable code generation in commercial .NET O/R mappers, I have decided to give up on them. My vision for this project is a simple code file generation class library driven by an administration GUI as a separate Winform application. It will use an easy to understand factory pattern. Files will be kept very small and easy to manage, and best of all, there will be no designer and impossible to read five thousand line long xml or C# code files. The idea of this project is simple. In one click, take a database and generate a simple, maintainable data access layer that just works. All default CRUD operations will be generated using LINQ. There will be no possibility of designer files becoming corrupt and wiping out your O/R Mappings while you try to find that one character in that 5000 line long XML configuration to fix it. Simple is better, but if developers need more flexibility, a series of extension classes will be available to build on top of the core data access layer. I never want a developer to have to touch the core for any reason. It will be a one click operation to build a data access layer for a small application, but it will have the ability to be customized for complex applications as well. I plan to port the functionality as a visual studio plug-in down the road.

anito.NET - Object Relational Mapping Framework

anito.zip (10,2 MB)
Anito.net is an under development, simple, open source Object Relational Mapping framework for .Net that aims to speed up database-driven development through reusable patterns and database independent solutions. Supported database MS-SQL, MySQL, SQLite and MongoDB

patterns & practices: Application Architecture Guide 2.0

patterns & practices Application Architecture Guide 2.0 Community Site

AppConfig Code Generator

AppConfig Code Generator, developed in C#, is a Custom Tool for Visual Studio 2008 and 2010 which generates a helper class in order to access to the Configuration AppSettings and ConnectionStrings.

Binding Framework

Binding Framework makes it easier for developers to bind business objects to view objects using string rule. You'll no longer have to write code which parses string to extract primary keys, load business objects by primary keys to view properties.

Classic Data Access Layer Helpers

Classic data access layer is nothing but querying data from database, extracting & packing data into CLR typed classes. Classic DAL Helpers makes it easier for back-end layers, especially for Data Access Objects to extract and fill data. Its developed in Microsoft .NET 3.5, C#.

Coconut Dal

coconutdal.zip (3,2 MB)
Coconut Dal is a lightweight data access layer, for use in projects where developers might otherwise be tempted to write native ADO.NET code instead of using a fully-featured library, such as Entity Framework or Microsoft's Enterprise Library.

CodeFx a .NET2.0 based persistence framework

CodeFx.zip (361 kB)
CodeFx is a .NET based persistence framework (DAL, DTO, Persistence) working with attributes. The mapping with tables can be made with codesmith templates or manually. Either a table pattern or a business implementation can be made depending on the the architecture approach. The DataBase used is MySql but the templates can be updated for others Db. The type of persistence is defined is the Persistance classes with attributes: [Persistance("ClassName" , EPersistanceMode.Cache, EPersistanceLevel.Public)] Persistence is a mix between the persistance Mode (Cache, Session , Items) and the Level (Public or Private). The DTO classes are implemented with [DataObject] attributes so that asp.net ObjectDataSource can be used in a standard way. This framework is on production for the sites www.talentexpo.fr and www.bestperf.com since beginning of 2007 Chek the CodeFxMySqlProvider project for an complete example of using this framework. *******French Version******* CodeFx est un framework OpenSource géré sur CodePlex, le site communautaire Open Source .Net. C'est un framework de persistance développé initialement pour le site TalentExpo puis réutilisé pour Bestperf. Il est en production depuis maintenant quelques mois. Développé en C# sur le framework 2.0, il est utilisé avec des templates CodeSmith qui permettent de générér, en s'appuyant sur le schéma d'une base MySql, l'ensemble des classes de type DAL, DTO et Persistance. Ces classes peuvent également être définies manuellement afin de pouvoir définir des classes business. La persistance, mix entre le mode (Cache, Session, IIS) et le niveau (Public, Private), est définie par attribut sur les classes de types Persistance: [Persistance("ClassName" , EPersistanceMode.Cache, EPersistanceLevel.Public)] Les classes DTO sont implémentées avec les attributs [DataObject] afin de pouvoir utiliser les ObjectDataSource d'asp.net de manière standard. Voir le projet CodeFxMySqlProvider pour un exemple complet d'utilisation.

CoreSystem Library

coresystem.zip (11,3 MB)
Contains classes that help during development

crudwork library

crudwork.zip (27,9 MB)
crudwork is a collection of reuseable components for .NET applications.

CslaGenFork

cslagenfork.zip (72,1 MB)
O/RM code generator for CSLA.NET 4.3/4.. generating Stored Procedures, Business Layer and Data Access Layer code for Windows Forms, ASP.NET, WPF and Silverlight

Data Access Component

dac.zip (101,2 MB)
Just as the name, it's an data access component. It provides a library of classes and a tool, using it in .net project can make data accessing more easily.

Data Access Engine (DAE)

dae.zip (6,3 MB)
Data Access Engine (DAE) is an open source and free .NET component to access all popular DBMSs such as Microsoft SQL Server, MySQL, Oracle, Microsoft Access, SQLite and databases that connected by ODBC. DAE helps to connect different DBMSs at the same time.

DAEE (DataAccess extended from Enterprise Library 3.1)

daee.zip (2,4 MB)
Based on Enterprise Library 3.1, DAEE enables developers to access databases faster and safer. DAEE supports multiple database sources including ACCESS/ SQLSERVER2000/ SQLSERVER2005/ ODBC/ ORACLE/ EXCEL etc. You can configure connection strings in WEB.CONFIG/ APP.CONFIG through Microsoft Enterprise Library Configuration Tool. DAEE have many other features, including the following ones: 1. Enabling operations crossing multiple databases at the same time. 2. Supporting executions of multiple operations with a transaction. 3. Supporting pagination of single table operation, skip of specific records (only SQLSERVER2005 is available now). 4. High security level, preventing from SQL Injection Attack. 5. Other features. System Requirements * Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP Note: If you already have the Enterprise Library 3.0 installed, you must uninstall it before installing the Enterprise Library 3.1. However, you can install the Enterprise Library 3.0 or the Enterprise Library 3.1 when 2.0 is already installed. * Microsoft .NET Framework 2.0 or 3.0. You need .NET Framework 3.0 for the Application Block Software Factory and the WCF adapters for the Validation Application Block and Exception Handling Application Block * Microsoft Visual Studio 2005 development system (any of the following editions): o Microsoft Visual Studio 2005 Standard Edition o Microsoft Visual Studio 2005 Professional Edition o Microsoft Visual Studio 2005 Team Edition for Software Developers o Microsoft Visual Studio 2005 Team Edition for Software Testers o Microsoft Visual Studio 2005 Team Edition for Software Architects o Microsoft Visual Studio 2005 Team Suite * To use the Application Block Software Factory and the Strong-Naming Guidance Package, you need the Guidance Automation Extensions (GAX). To modify these guidance packages, you also need the Guidance

DAL

DAL.zip (230 kB)
OOP Data Access Layer for .net 2.0

Simple DAL Code Generator for SQL Server

dalcog.zip (3,3 MB)
DALCOG or COG is a data access layer code generator. It generates the sources in C# and CRUD stored procedures for SQL Server.

DALHelper

DALHelper.zip (737 kB)
Connect to your SQL Server database easily, efficiently, writing minimal code.

Data Access Object Generator (c# .net) for MySQL Database

Data Access Layer Generator for MySQL. Enabling .net development much faster using mysql database.